<?php

session_start();

$page = 'cartindex.php';

$connect = mysql_connect("localhost", "root", "pratt3284") or die (mysql_error());
mysql_select_db("cart") or die (mysql_error());

if(isset($_GET['add'])){
	$quantity = mysql_query('SELECT id, quantity FROM products WHERE id='.mysql_real_escape_string((int)$_GET['add']));
	while($quantity_row = mysql_fetch_assoc($quantity)){
		if($quantity_row['quantity']!=$_SESSION['cart_'.$_GET['add']]){
			@$_SESSION['cart_'.$_GET['add']]+='1';
		}
	}
}

function products(){
	$get = mysql_query("SELECT id, name, description, price FROM products WHERE quantity > 0 ORDER BY id DESC");
	
	if(mysql_num_rows($get)==0){
		echo "There are no products to display";
	}
	else{
		while($get_row = mysql_fetch_assoc($get)){
			echo '<p>'.$get_row['name'].'<br>'.$get_row['description'].'<br>'.number_format($get_row['price'], 2).'<a href="cart.php?add='.$get_row['id'].'">			
					Add</a></p>';
		}
	}
}

function cart(){
	foreach($_SESSION as $name => $value){
		echo 'test';
		if($value>0){
			if(substr($name, 0, 5)=='cart_'){
				echo $name.'<br>';
			}
		}
		else
			echo "Your cart is empty.";
	}
}
?>